ALTER TABLE Customer ADD WareHouseCode NVARCHAR(20)

alter table Customer
   add constraint FK_WareHouse_Customer foreign key (WareHouseCode)
      references WareHouse (Code)
go